update ax_layoutdesign set content ='[{"transid":"NF_AG","compressedMode":true,"newDesign":true,"staticRunMode":false,"wizardDC":false,"selectedLayout":"default","tstUpdatedOn":"02-11-2021 17:43:51","dcs":[{"dc_id":"1","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"name","x":0,"y":0,"width":6,"height":1,"visibility":true},{"fld_id":"caption","x":6,"y":0,"width":13,"height":1,"visibility":true},{"fld_id":"dcselect","x":19,"y":0,"width":10,"height":1,"visibility":true},{"fld_id":"assgrid","x":29,"y":0,"width":3,"height":1,"visibility":true},{"fld_id":"customdatatype","x":0,"y":1,"width":6,"height":1,"visibility":true},{"fld_id":"cdatatype","x":6,"y":1,"width":7,"height":1,"visibility":true},{"fld_id":"datatype","x":13,"y":1,"width":6,"height":1,"visibility":true},{"fld_id":"datawidth","x":19,"y":1,"width":4,"height":1,"visibility":true},{"fld_id":"fdecimal","x":23,"y":1,"width":4,"height":1,"visibility":true},{"fld_id":"savevale","x":28,"y":1,"width":4,"height":1,"visibility":true},{"fld_id":"purpose","x":0,"y":2,"width":32,"height":2,"visibility":true}],"tableDesign":null},{"dc_id":"2","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"modeofentry","x":0,"y":0,"width":25,"height":1,"visibility":true},{"fld_id":"acceptchoice","x":0,"y":1,"width":5,"height":1,"visibility":true},{"fld_id":"Def_Sequence","x":0,"y":2,"width":13,"height":1,"visibility":true},{"fld_id":"dsf","x":0,"y":3,"width":24,"height":1,"visibility":true},{"fld_id":"apidefname","x":0,"y":4,"width":10,"height":1,"visibility":true},{"fld_id":"Def_table","x":0,"y":5,"width":33,"height":7,"visibility":true},{"fld_id":"sql_editor_detail","x":0,"y":12,"width":32,"height":3,"visibility":true},{"fld_id":"suggestive","x":0,"y":15,"width":4,"height":1,"visibility":true},{"fld_id":"refreshonsave","x":4,"y":15,"width":6,"height":1,"visibility":true},{"fld_id":"masterdl","x":0,"y":16,"width":14,"height":1,"visibility":true},{"fld_id":"source","x":15,"y":16,"width":16,"height":1,"visibility":true},{"fld_id":"exp_editor_expression","x":0,"y":17,"width":32,"height":2,"visibility":true}],"tableDesign":null},{"dc_id":"3","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"exp_editor_validateexpression","x":0,"y":0,"width":32,"height":2,"visibility":true},{"fld_id":"allowempty","x":0,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"allowduplicate","x":5,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"onlypositive","x":10,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"clienvalidation","x":15,"y":2,"width":6,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"4","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"hidden","x":0,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"readonly","x":4,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"applycomma","x":8,"y":0,"width":5,"height":1,"visibility":true},{"fld_id":"setcarry","x":13,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"tabstop","x":17,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"hideinsearch","x":0,"y":1,"width":5,"height":1,"visibility":true},{"fld_id":"pwdalphachar","x":5,"y":1,"width":15,"height":1,"visibility":true},{"fld_id":"pwdchar","x":0,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"pwdlength","x":9,"y":2,"width":11,"height":1,"visibility":true},{"fld_id":"pwdexpiry","x":20,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"createafterddl","x":0,"y":3,"width":9,"height":1,"visibility":true},{"fld_id":"mask","x":9,"y":3,"width":11,"height":1,"visibility":true},{"fld_id":"pattern","x":20,"y":3,"width":9,"height":1,"visibility":true},{"fld_id":"componenttype","x":0,"y":4,"width":9,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"5","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"prefix","x":0,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"prefixfield","x":9,"y":0,"width":12,"height":1,"visibility":true},{"fld_id":"startingno","x":21,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"active","x":0,"y":1,"width":9,"height":1,"visibility":true},{"fld_id":"noofdigits","x":9,"y":1,"width":9,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct5","width":0,"visibility":true},{"fld_id":"uniqueThHead5","width":0,"visibility":true},{"fld_id":"axp_recid5","width":11,"visibility":false},{"fld_id":"prefix","width":150,"visibility":true},{"fld_id":"prefixfield","width":240,"visibility":true},{"fld_id":"startingno","width":150,"visibility":true},{"fld_id":"active","width":150,"visibility":true},{"fld_id":"rowcountt","width":11,"visibility":false},{"fld_id":"activecount","width":11,"visibility":false},{"fld_id":"noofdigits","width":150,"visibility":true},{"fld_id":"dupck","width":11,"visibility":false}]}]}]'
where transid ='NF_AG';

update ax_layoutdesign_saved set content ='[{"transid":"NF_AG","compressedMode":true,"newDesign":true,"staticRunMode":false,"wizardDC":false,"selectedLayout":"default","tstUpdatedOn":"02-11-2021 17:43:51","dcs":[{"dc_id":"1","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"name","x":0,"y":0,"width":6,"height":1,"visibility":true},{"fld_id":"caption","x":6,"y":0,"width":13,"height":1,"visibility":true},{"fld_id":"dcselect","x":19,"y":0,"width":10,"height":1,"visibility":true},{"fld_id":"assgrid","x":29,"y":0,"width":3,"height":1,"visibility":true},{"fld_id":"customdatatype","x":0,"y":1,"width":6,"height":1,"visibility":true},{"fld_id":"cdatatype","x":6,"y":1,"width":7,"height":1,"visibility":true},{"fld_id":"datatype","x":13,"y":1,"width":6,"height":1,"visibility":true},{"fld_id":"datawidth","x":19,"y":1,"width":4,"height":1,"visibility":true},{"fld_id":"fdecimal","x":23,"y":1,"width":4,"height":1,"visibility":true},{"fld_id":"savevale","x":28,"y":1,"width":4,"height":1,"visibility":true},{"fld_id":"purpose","x":0,"y":2,"width":32,"height":2,"visibility":true}],"tableDesign":null},{"dc_id":"2","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"modeofentry","x":0,"y":0,"width":25,"height":1,"visibility":true},{"fld_id":"acceptchoice","x":0,"y":1,"width":5,"height":1,"visibility":true},{"fld_id":"Def_Sequence","x":0,"y":2,"width":13,"height":1,"visibility":true},{"fld_id":"dsf","x":0,"y":3,"width":24,"height":1,"visibility":true},{"fld_id":"apidefname","x":0,"y":4,"width":10,"height":1,"visibility":true},{"fld_id":"Def_table","x":0,"y":5,"width":33,"height":7,"visibility":true},{"fld_id":"sql_editor_detail","x":0,"y":12,"width":32,"height":3,"visibility":true},{"fld_id":"suggestive","x":0,"y":15,"width":4,"height":1,"visibility":true},{"fld_id":"refreshonsave","x":4,"y":15,"width":6,"height":1,"visibility":true},{"fld_id":"masterdl","x":0,"y":16,"width":14,"height":1,"visibility":true},{"fld_id":"source","x":15,"y":16,"width":16,"height":1,"visibility":true},{"fld_id":"exp_editor_expression","x":0,"y":17,"width":32,"height":2,"visibility":true}],"tableDesign":null},{"dc_id":"3","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"exp_editor_validateexpression","x":0,"y":0,"width":32,"height":2,"visibility":true},{"fld_id":"allowempty","x":0,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"allowduplicate","x":5,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"onlypositive","x":10,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"clienvalidation","x":15,"y":2,"width":6,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"4","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"hidden","x":0,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"readonly","x":4,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"applycomma","x":8,"y":0,"width":5,"height":1,"visibility":true},{"fld_id":"setcarry","x":13,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"tabstop","x":17,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"hideinsearch","x":0,"y":1,"width":5,"height":1,"visibility":true},{"fld_id":"pwdalphachar","x":5,"y":1,"width":15,"height":1,"visibility":true},{"fld_id":"pwdchar","x":0,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"pwdlength","x":9,"y":2,"width":11,"height":1,"visibility":true},{"fld_id":"pwdexpiry","x":20,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"createafterddl","x":0,"y":3,"width":9,"height":1,"visibility":true},{"fld_id":"mask","x":9,"y":3,"width":11,"height":1,"visibility":true},{"fld_id":"pattern","x":20,"y":3,"width":9,"height":1,"visibility":true},{"fld_id":"componenttype","x":0,"y":4,"width":9,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"5","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"prefix","x":0,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"prefixfield","x":9,"y":0,"width":12,"height":1,"visibility":true},{"fld_id":"startingno","x":21,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"active","x":0,"y":1,"width":9,"height":1,"visibility":true},{"fld_id":"noofdigits","x":9,"y":1,"width":9,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct5","width":0,"visibility":true},{"fld_id":"uniqueThHead5","width":0,"visibility":true},{"fld_id":"axp_recid5","width":11,"visibility":false},{"fld_id":"prefix","width":150,"visibility":true},{"fld_id":"prefixfield","width":240,"visibility":true},{"fld_id":"startingno","width":150,"visibility":true},{"fld_id":"active","width":150,"visibility":true},{"fld_id":"rowcountt","width":11,"visibility":false},{"fld_id":"activecount","width":11,"visibility":false},{"fld_id":"noofdigits","width":150,"visibility":true},{"fld_id":"dupck","width":11,"visibility":false}]}]}]'
where transid ='NF_AG';

update ax_layoutdesign set content ='[{"transid":"NF_AG","compressedMode":true,"newDesign":true,"staticRunMode":false,"wizardDC":false,"selectedLayout":"default","tstUpdatedOn":"29-06-2022 13:42:42","dcs":[{"dc_id":"1","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"name","x":0,"y":0,"width":6,"height":1,"visibility":true},{"fld_id":"caption","x":6,"y":0,"width":13,"height":1,"visibility":true},{"fld_id":"dcselect","x":19,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"assgrid","x":28,"y":0,"width":3,"height":1,"visibility":true},{"fld_id":"savevale","x":31,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"customdatatype","x":0,"y":1,"width":6,"height":1,"visibility":true},{"fld_id":"cdatatype","x":6,"y":1,"width":7,"height":1,"visibility":true},{"fld_id":"datatype","x":13,"y":1,"width":6,"height":1,"visibility":true},{"fld_id":"datawidth","x":19,"y":1,"width":4,"height":1,"visibility":true},{"fld_id":"fdecimal","x":23,"y":1,"width":4,"height":1,"visibility":true},{"fld_id":"runtimecriteria","x":27,"y":1,"width":8,"height":1,"visibility":true},{"fld_id":"purpose","x":0,"y":2,"width":32,"height":2,"visibility":true}],"tableDesign":null},{"dc_id":"2","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"modeofentry","x":0,"y":0,"width":25,"height":1,"visibility":true},{"fld_id":"acceptchoice","x":0,"y":1,"width":5,"height":1,"visibility":true},{"fld_id":"Def_Sequence","x":0,"y":2,"width":13,"height":1,"visibility":true},{"fld_id":"dsf","x":0,"y":3,"width":24,"height":1,"visibility":true},{"fld_id":"apidefname","x":0,"y":4,"width":10,"height":1,"visibility":true},{"fld_id":"Def_table","x":0,"y":5,"width":33,"height":7,"visibility":true},{"fld_id":"sql_editor_detail","x":0,"y":12,"width":32,"height":3,"visibility":true},{"fld_id":"suggestive","x":0,"y":15,"width":4,"height":1,"visibility":true},{"fld_id":"refreshonsave","x":4,"y":15,"width":6,"height":1,"visibility":true},{"fld_id":"masterdl","x":0,"y":16,"width":14,"height":1,"visibility":true},{"fld_id":"source","x":15,"y":16,"width":16,"height":1,"visibility":true},{"fld_id":"exp_editor_expression","x":0,"y":17,"width":32,"height":2,"visibility":true},{"fld_id":"suggestive_fill","x":0,"y":19,"width":9,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"3","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"exp_editor_validateexpression","x":0,"y":0,"width":32,"height":2,"visibility":true},{"fld_id":"allowempty","x":0,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"allowduplicate","x":5,"y":2,"width":6,"height":1,"visibility":true},{"fld_id":"onlypositive","x":11,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"clienvalidation","x":16,"y":2,"width":6,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"4","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"hidden","x":0,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"readonly","x":4,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"applycomma","x":8,"y":0,"width":5,"height":1,"visibility":true},{"fld_id":"setcarry","x":13,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"tabstop","x":17,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"hideinsearch","x":0,"y":1,"width":5,"height":1,"visibility":true},{"fld_id":"pwdalphachar","x":5,"y":1,"width":15,"height":1,"visibility":true},{"fld_id":"pwdchar","x":0,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"pwdlength","x":9,"y":2,"width":11,"height":1,"visibility":true},{"fld_id":"pwdexpiry","x":20,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"createafterddl","x":0,"y":3,"width":9,"height":1,"visibility":true},{"fld_id":"mask","x":9,"y":3,"width":11,"height":1,"visibility":true},{"fld_id":"pattern","x":20,"y":3,"width":9,"height":1,"visibility":true},{"fld_id":"componenttype","x":0,"y":4,"width":9,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"5","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"prefix","x":0,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"prefixfield","x":9,"y":0,"width":12,"height":1,"visibility":true},{"fld_id":"startingno","x":21,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"active","x":0,"y":1,"width":9,"height":1,"visibility":true},{"fld_id":"noofdigits","x":9,"y":1,"width":9,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct5","width":0,"visibility":true},{"fld_id":"uniqueThHead5","width":0,"visibility":true},{"fld_id":"axp_recid5","width":11,"visibility":false},{"fld_id":"prefix","width":150,"visibility":true},{"fld_id":"prefixfield","width":240,"visibility":true},{"fld_id":"startingno","width":150,"visibility":true},{"fld_id":"active","width":150,"visibility":true},{"fld_id":"rowcountt","width":11,"visibility":false},{"fld_id":"activecount","width":11,"visibility":false},{"fld_id":"noofdigits","width":150,"visibility":true},{"fld_id":"dupck","width":11,"visibility":false}]}]}]'
where transid ='NF_AG';

update ax_layoutdesign_saved set content ='[{"transid":"NF_AG","compressedMode":true,"newDesign":true,"staticRunMode":false,"wizardDC":false,"selectedLayout":"default","tstUpdatedOn":"29-06-2022 13:42:42","dcs":[{"dc_id":"1","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"name","x":0,"y":0,"width":6,"height":1,"visibility":true},{"fld_id":"caption","x":6,"y":0,"width":13,"height":1,"visibility":true},{"fld_id":"dcselect","x":19,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"assgrid","x":28,"y":0,"width":3,"height":1,"visibility":true},{"fld_id":"savevale","x":31,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"customdatatype","x":0,"y":1,"width":6,"height":1,"visibility":true},{"fld_id":"cdatatype","x":6,"y":1,"width":7,"height":1,"visibility":true},{"fld_id":"datatype","x":13,"y":1,"width":6,"height":1,"visibility":true},{"fld_id":"datawidth","x":19,"y":1,"width":4,"height":1,"visibility":true},{"fld_id":"fdecimal","x":23,"y":1,"width":4,"height":1,"visibility":true},{"fld_id":"runtimecriteria","x":27,"y":1,"width":8,"height":1,"visibility":true},{"fld_id":"purpose","x":0,"y":2,"width":32,"height":2,"visibility":true}],"tableDesign":null},{"dc_id":"2","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"modeofentry","x":0,"y":0,"width":25,"height":1,"visibility":true},{"fld_id":"acceptchoice","x":0,"y":1,"width":5,"height":1,"visibility":true},{"fld_id":"Def_Sequence","x":0,"y":2,"width":13,"height":1,"visibility":true},{"fld_id":"dsf","x":0,"y":3,"width":24,"height":1,"visibility":true},{"fld_id":"apidefname","x":0,"y":4,"width":10,"height":1,"visibility":true},{"fld_id":"Def_table","x":0,"y":5,"width":33,"height":7,"visibility":true},{"fld_id":"sql_editor_detail","x":0,"y":12,"width":32,"height":3,"visibility":true},{"fld_id":"suggestive","x":0,"y":15,"width":4,"height":1,"visibility":true},{"fld_id":"refreshonsave","x":4,"y":15,"width":6,"height":1,"visibility":true},{"fld_id":"masterdl","x":0,"y":16,"width":14,"height":1,"visibility":true},{"fld_id":"source","x":15,"y":16,"width":16,"height":1,"visibility":true},{"fld_id":"exp_editor_expression","x":0,"y":17,"width":32,"height":2,"visibility":true},{"fld_id":"suggestive_fill","x":0,"y":19,"width":9,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"3","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"exp_editor_validateexpression","x":0,"y":0,"width":32,"height":2,"visibility":true},{"fld_id":"allowempty","x":0,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"allowduplicate","x":5,"y":2,"width":6,"height":1,"visibility":true},{"fld_id":"onlypositive","x":11,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"clienvalidation","x":16,"y":2,"width":6,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"4","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"hidden","x":0,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"readonly","x":4,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"applycomma","x":8,"y":0,"width":5,"height":1,"visibility":true},{"fld_id":"setcarry","x":13,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"tabstop","x":17,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"hideinsearch","x":0,"y":1,"width":5,"height":1,"visibility":true},{"fld_id":"pwdalphachar","x":5,"y":1,"width":15,"height":1,"visibility":true},{"fld_id":"pwdchar","x":0,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"pwdlength","x":9,"y":2,"width":11,"height":1,"visibility":true},{"fld_id":"pwdexpiry","x":20,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"createafterddl","x":0,"y":3,"width":9,"height":1,"visibility":true},{"fld_id":"mask","x":9,"y":3,"width":11,"height":1,"visibility":true},{"fld_id":"pattern","x":20,"y":3,"width":9,"height":1,"visibility":true},{"fld_id":"componenttype","x":0,"y":4,"width":9,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"5","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"prefix","x":0,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"prefixfield","x":9,"y":0,"width":12,"height":1,"visibility":true},{"fld_id":"startingno","x":21,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"active","x":0,"y":1,"width":9,"height":1,"visibility":true},{"fld_id":"noofdigits","x":9,"y":1,"width":9,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct5","width":0,"visibility":true},{"fld_id":"uniqueThHead5","width":0,"visibility":true},{"fld_id":"axp_recid5","width":11,"visibility":false},{"fld_id":"prefix","width":150,"visibility":true},{"fld_id":"prefixfield","width":240,"visibility":true},{"fld_id":"startingno","width":150,"visibility":true},{"fld_id":"active","width":150,"visibility":true},{"fld_id":"rowcountt","width":11,"visibility":false},{"fld_id":"activecount","width":11,"visibility":false},{"fld_id":"noofdigits","width":150,"visibility":true},{"fld_id":"dupck","width":11,"visibility":false}]}]}]'
where transid ='NF_AG';

alter table tstructs add runtimemod varchar(10);


CREATE OR REPLACE VIEW vw_tstructs
AS SELECT a.ntransid AS transid,
    a.caption,
    a.purpose,
    a.savecontrolfield AS savecontrol,
    a.deletecontrolfield AS deletecontrol,
    a.trackchanges,
    a.attachment,
    a.listview,
    a.workflow,
    a.schema,
        CASE
            WHEN a.isacoretrans::text = 'Yes'::text THEN 'No'::text
            ELSE 'Yes'::text
        END AS isacoretrans,
    a.menuposition,
    a.menulist,
    a.selectfieldlist,
    a.selectuserlist,
    a.trackchangesmadeby,
    a.trackchangesfield,
    a.layouttype,
    COALESCE(a.includepage, 'F'::character varying) AS includepage,
    a.runtimemod
   FROM axpdef_tstruct a;


  CREATE OR REPLACE view vw_field_informations
AS SELECT DISTINCT 1 AS sno,
    a.stransid AS transid,
    a.dcname,
    a.name,
    a.caption,
    a.datatype,
    a.customdatatype,
    a.datawidth,
    a.fdecimal,
    a.modeofentry,
    a.sql_editor_detail AS detail,
        CASE
            WHEN a.hidden::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS hidden,
        CASE
            WHEN a.allowempty::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowempty,
        CASE
            WHEN a.readonly::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS readonly,
        CASE
            WHEN a.setcarry::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS setcarry,
        CASE
            WHEN a.savevale::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS savevalue,
    a.exp_editor_expression AS expression,
    a.exp_editor_validateexpression AS validateexpression,
        CASE
            WHEN a.allowduplicate::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowduplicate,
        CASE
            WHEN a.onlypositive::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS onlypositive,
    NULL::text AS sourcekey,
    NULL::text AS carryfield,
    NULL::text AS displaytotal,
    NULL::text AS windowwidth,
    NULL::text AS windowheight,
    NULL::text AS sql,
        CASE
            WHEN a.autoselect::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS autoselect,
        CASE
            WHEN a.refreshonsave::text = 'F'::text THEN 'FALSE'::text
            ELSE 'TRUE'::text
        END AS refresh,
    NULL::text AS listvalues,
    NULL::text AS prefix,
    NULL::text AS prefix_fields,
    NULL::text AS description,
    NULL::text AS start_no,
    'FALSE'::text AS sactive,
    NULL::text AS no_of_digits,
    'FALSE'::text AS savenormalized,
        CASE
            WHEN a.suggestive::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS suggestive,
    NULL::text AS sourcefield,
    NULL::text AS source_table,
    NULL::text AS datasource,
    NULL::text AS sequence,
    NULL::text AS tname,
    NULL::text AS fromtransid,
    NULL::text AS selectfield,
    NULL::text AS parent,
    NULL::text AS gui,
        CASE
            WHEN a.applycomma::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS applycomma,
    a.mask,
    a.pattern,
    a.pwdchar AS password_character,
    a.hint,
        CASE
            WHEN a.clienvalidation::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS clientvalidation,
    a.searchsql AS search_sql,
    a.displaydetails AS displaydetail,
        CASE
            WHEN a.tabstop::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS tabstop,
    m.sleveno,
    m.sordno,
    NULL::text AS source,
    a.purpose,
    NULL::text AS cwidth,
    NULL::text AS list,
    NULL::text AS selectform,
    a.fldordno,
    m.trackchanges,
    m.trackchangesmadeby,
    m.selectedusers,
    m.selectedfields,
    NULL::text AS master,
    'FALSE'::text AS combobox,
    a.componenttype,
    a.separator,
    a.def_table,
    a.hideinsearch,
    a.mastertstruct,
    a.masterfield,
    a.dsf,
    a.def_sequence,
        CASE
            WHEN a.pwdalphachar::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS password_alphanumeric,
    a.pwdlength AS password_minlength,
    a.pwdexpiry AS password_expirydays,
    s.execapiurl,
    s.execapiparameterstring,
    s.execapiheaderstring,
    s.execapirequeststring,
    s.apiresponsetype,
    s.apiresponseformat,
    a.apifieldname,
    s.execapidefname,
    a.runtimecriteria
   FROM coretstructhdr a
     JOIN tstruct_mst_details m ON a.coretstructhdrid = m.sourceid
     LEFT JOIN executeapidef s ON a.apidefname = s.executeapidefid
  WHERE lower(a.modeofentry::text) = ANY (ARRAY['accept'::character varying::text, 'calculate'::character varying::text, 'from api'::character varying::text])
UNION
 SELECT DISTINCT 2 AS sno,
    a.stransid AS transid,
    a.dcname,
    a.name,
    a.caption,
    a.datatype,
    a.customdatatype,
    a.datawidth,
    a.fdecimal,
    a.modeofentry,
    a.sql_editor_detail AS detail,
        CASE
            WHEN a.hidden::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS hidden,
        CASE
            WHEN a.allowempty::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowempty,
        CASE
            WHEN a.readonly::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS readonly,
        CASE
            WHEN a.setcarry::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS setcarry,
        CASE
            WHEN a.savevale::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS savevalue,
    a.exp_editor_expression AS expression,
    a.exp_editor_validateexpression AS validateexpression,
        CASE
            WHEN a.allowduplicate::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowduplicate,
        CASE
            WHEN a.onlypositive::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS onlypositive,
    NULL::text AS sourcekey,
    NULL::text AS carryfield,
    NULL::text AS displaytotal,
    NULL::text AS windowwidth,
    NULL::text AS windowheight,
    NULL::text AS sql,
    'FALSE'::text AS autoselect,
    'FALSE'::text AS refresh,
    NULL::text AS listvalues,
    NULL::text AS prefix,
    NULL::text AS prefix_fields,
    NULL::text AS description,
    NULL::text AS start_no,
    'FALSE'::text AS sactive,
    NULL::text AS no_of_digits,
    'FALSE'::text AS savenormalized,
    'FALSE'::text AS suggestive,
    NULL::text AS sourcefield,
    NULL::text AS source_table,
    NULL::text AS datasource,
    NULL::text AS sequence,
    NULL::text AS tname,
    NULL::text AS fromtransid,
    NULL::text AS selectfield,
    NULL::text AS parent,
    NULL::text AS gui,
        CASE
            WHEN a.applycomma::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS applycomma,
    a.mask,
    a.pattern,
    a.pwdchar AS password_character,
    a.hint,
        CASE
            WHEN a.clienvalidation::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS clientvalidation,
    a.searchsql AS search_sql,
    a.displaydetails AS displaydetail,
        CASE
            WHEN a.tabstop::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS tabstop,
    m.sleveno,
    m.sordno,
    NULL::text AS source,
    a.purpose,
    NULL::text AS cwidth,
    NULL::text AS list,
    NULL::text AS selectform,
    a.fldordno,
    m.trackchanges,
    m.trackchangesmadeby,
    m.selectedusers,
    m.selectedfields,
    NULL::text AS master,
    'FALSE'::text AS combobox,
    a.componenttype,
    a.separator,
    a.def_table,
    a.hideinsearch,
    a.mastertstruct,
    a.masterfield,
    a.dsf,
    a.def_sequence,
        CASE
            WHEN a.pwdalphachar::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS password_alphanumeric,
    a.pwdlength AS password_minlength,
    a.pwdexpiry AS password_expirydays,
    NULL::text AS execapiurl,
    NULL::text AS execapiparameterstring,
    NULL::text AS execapiheaderstring,
    NULL::text AS execapirequeststring,
    NULL::text AS apiresponsetype,
    NULL::text AS apiresponseformat,
    NULL::text AS apifieldname,
    NULL::text AS execapidefname,
    a.runtimecriteria
   FROM coretstructhdr a,
    tstruct_mst_details m
  WHERE a.coretstructhdrid = m.sourceid AND lower(a.modeofentry::text) = 'autogenerate'::text
UNION
 SELECT DISTINCT 3 AS sno,
    a.stransid AS transid,
    a.dcname,
    a.name,
    a.caption,
    a.datatype,
    a.customdatatype,
    a.datawidth,
    a.fdecimal,
    a.modeofentry,
    a.sql_editor_detail AS detail,
        CASE
            WHEN a.hidden::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS hidden,
        CASE
            WHEN a.allowempty::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowempty,
        CASE
            WHEN a.readonly::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS readonly,
        CASE
            WHEN a.setcarry::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS setcarry,
        CASE
            WHEN a.savevale::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS savevalue,
    a.exp_editor_expression AS expression,
    a.exp_editor_validateexpression AS validateexpression,
        CASE
            WHEN a.allowduplicate::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowduplicate,
        CASE
            WHEN a.onlypositive::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS onlypositive,
    NULL::text AS sourcekey,
    NULL::text AS carryfield,
    NULL::text AS displaytotal,
    NULL::text AS windowwidth,
    NULL::text AS windowheight,
    NULL::text AS sql,
    'FALSE'::text AS autoselect,
    'FALSE'::text AS refresh,
    a.def_list AS listvalues,
    NULL::text AS prefix,
    NULL::text AS prefix_fields,
    NULL::text AS description,
    NULL::text AS start_no,
    'FALSE'::text AS sactive,
    NULL::text AS no_of_digits,
    'FALSE'::text AS savenormalized,
    'FALSE'::text AS suggestive,
    NULL::text AS sourcefield,
    NULL::text AS source_table,
    NULL::text AS datasource,
    NULL::text AS sequence,
    NULL::text AS tname,
    NULL::text AS fromtransid,
    NULL::text AS selectfield,
    NULL::text AS parent,
    NULL::text AS gui,
        CASE
            WHEN a.applycomma::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS applycomma,
    a.mask,
    a.pattern,
    a.pwdchar AS password_character,
    a.hint,
        CASE
            WHEN a.clienvalidation::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS clientvalidation,
    a.searchsql AS search_sql,
    a.displaydetails AS displaydetail,
        CASE
            WHEN a.tabstop::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS tabstop,
    m.sleveno,
    m.sordno,
    NULL::text AS source,
    a.purpose,
    NULL::text AS cwidth,
    NULL::text AS list,
    NULL::text AS selectform,
    a.fldordno,
    m.trackchanges,
    m.trackchangesmadeby,
    m.selectedusers,
    m.selectedfields,
    NULL::text AS master,
    'FALSE'::text AS combobox,
    a.componenttype,
    a.separator,
    a.def_table,
    a.hideinsearch,
    a.mastertstruct,
    a.masterfield,
    a.dsf,
    a.def_sequence,
        CASE
            WHEN a.pwdalphachar::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS password_alphanumeric,
    a.pwdlength AS password_minlength,
    a.pwdexpiry AS password_expirydays,
    NULL::text AS execapiurl,
    NULL::text AS execapiparameterstring,
    NULL::text AS execapiheaderstring,
    NULL::text AS execapirequeststring,
    NULL::text AS apiresponsetype,
    NULL::text AS apiresponseformat,
    NULL::text AS apifieldname,
    NULL::text AS execapidefname,
    a.runtimecriteria
   FROM coretstructhdr a,
    tstruct_mst_details m
  WHERE a.coretstructhdrid = m.sourceid AND lower(a.modeofentry::text) = 'select from list'::text
UNION
 SELECT DISTINCT 4 AS sno,
    a.stransid AS transid,
    a.dcname,
    a.name,
    a.caption,
    a.datatype,
    a.customdatatype,
    a.datawidth,
    a.fdecimal,
    a.modeofentry,
    a.sql_editor_detail AS detail,
        CASE
            WHEN a.hidden::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS hidden,
        CASE
            WHEN a.allowempty::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowempty,
        CASE
            WHEN a.readonly::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS readonly,
        CASE
            WHEN a.setcarry::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS setcarry,
        CASE
            WHEN a.savevale::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS savevalue,
    a.exp_editor_expression AS expression,
    a.exp_editor_validateexpression AS validateexpression,
        CASE
            WHEN a.allowduplicate::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowduplicate,
        CASE
            WHEN a.onlypositive::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS onlypositive,
    'TRUE'::text AS sourcekey,
    NULL::text AS carryfield,
    NULL::text AS displaytotal,
    a.windowwidth_form::character(1) AS windowwidth,
    a.windowheight_form::character(1) AS windowheight,
    a.sql_editor_sqltextform AS sql,
        CASE
            WHEN a.autoselect_form::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS autoselect,
        CASE
            WHEN a.refreshonsave_form::text = 'F'::text THEN 'FALSE'::text
            ELSE 'TRUE'::text
        END AS refresh,
    NULL::text AS listvalues,
    NULL::text AS prefix,
    NULL::text AS prefix_fields,
    NULL::text AS description,
    NULL::text AS start_no,
    'FALSE'::text AS sactive,
    NULL::text AS no_of_digits,
        CASE
            WHEN a.savenormalized_form::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS savenormalized,
    'FALSE'::text AS suggestive,
    NULL::text AS sourcefield,
    a.tname AS source_table,
    a.datasource_form AS datasource,
    NULL::text AS sequence,
    NULL::text AS tname,
    a.fromtransid,
    a.selectfield,
    NULL::text AS parent,
    NULL::text AS gui,
        CASE
            WHEN a.applycomma::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS applycomma,
    a.mask,
    a.pattern,
    a.pwdchar AS password_character,
    a.hint,
        CASE
            WHEN a.clienvalidation::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS clientvalidation,
    a.searchsql AS search_sql,
    a.displaydetails AS displaydetail,
        CASE
            WHEN a.tabstop::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS tabstop,
    m.sleveno,
    m.sordno,
    NULL::text AS source,
    a.purpose,
    NULL::text AS cwidth,
    NULL::text AS list,
    NULL::text AS selectform,
    a.fldordno,
    m.trackchanges,
    m.trackchangesmadeby,
    m.selectedusers,
    m.selectedfields,
    NULL::text AS master,
        CASE
            WHEN a.combobox_form::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS combobox,
    a.componenttype,
    a.separator,
    a.def_table,
    a.hideinsearch,
    a.mastertstruct,
    a.masterfield,
    a.dsf,
    a.def_sequence,
        CASE
            WHEN a.pwdalphachar::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS password_alphanumeric,
    a.pwdlength AS password_minlength,
    a.pwdexpiry AS password_expirydays,
    NULL::text AS execapiurl,
    NULL::text AS execapiparameterstring,
    NULL::text AS execapiheaderstring,
    NULL::text AS execapirequeststring,
    NULL::text AS apiresponsetype,
    NULL::text AS apiresponseformat,
    NULL::text AS apifieldname,
    NULL::text AS execapidefname,
    a.runtimecriteria
   FROM coretstructhdr a,
    tstruct_mst_details m
  WHERE a.coretstructhdrid = m.sourceid AND lower(a.modeofentry::text) = 'select from form'::text
UNION
 SELECT DISTINCT 5 AS sno,
    a.stransid AS transid,
    a.dcname,
    a.name,
    a.caption,
    a.datatype,
    a.customdatatype,
    a.datawidth,
    a.fdecimal,
    a.modeofentry,
    a.sql_editor_detail AS detail,
        CASE
            WHEN a.hidden::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS hidden,
        CASE
            WHEN a.allowempty::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowempty,
        CASE
            WHEN a.readonly::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS readonly,
        CASE
            WHEN a.setcarry::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS setcarry,
        CASE
            WHEN a.savevale::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS savevalue,
    a.exp_editor_expression AS expression,
    a.exp_editor_validateexpression AS validateexpression,
        CASE
            WHEN a.allowduplicate::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowduplicate,
        CASE
            WHEN a.onlypositive::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS onlypositive,
        CASE
            WHEN a.savenormalized::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS sourcekey,
    NULL::text AS carryfield,
    NULL::text AS displaytotal,
    a.windowwidth::character(1) AS windowwidth,
    a.windowheight::character(1) AS windowheight,
    a.sql_editor_test AS sql,
        CASE
            WHEN a.autoselect_sql::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS autoselect,
        CASE
            WHEN a.refreshonsav::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS refresh,
    NULL::text AS listvalues,
    NULL::text AS prefix,
    NULL::text AS prefix_fields,
    NULL::text AS description,
    NULL::text AS start_no,
    'FALSE'::text AS sactive,
    NULL::text AS no_of_digits,
        CASE
            WHEN a.savenormalized::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS savenormalized,
    'FALSE'::text AS suggestive,
    a.sourcefield,
    a.sourcetable AS source_table,
    a.datasource,
    NULL::text AS sequence,
    NULL::text AS tname,
    NULL::text AS fromtransid,
    NULL::text AS selectfield,
    NULL::text AS parent,
    NULL::text AS gui,
        CASE
            WHEN a.applycomma::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS applycomma,
    a.mask,
    a.pattern,
    a.pwdchar AS password_character,
    a.hint,
        CASE
            WHEN a.clienvalidation::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS clientvalidation,
    a.searchsql AS search_sql,
    a.displaydetails AS displaydetail,
        CASE
            WHEN a.tabstop::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS tabstop,
    m.sleveno,
    m.sordno,
    NULL::text AS source,
    a.purpose,
    NULL::text AS cwidth,
    NULL::text AS list,
    a.selectform_ AS selectform,
    a.fldordno,
    m.trackchanges,
    m.trackchangesmadeby,
    m.selectedusers,
    m.selectedfields,
    NULL::text AS master,
        CASE
            WHEN a.combobox_sql::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS combobox,
    a.componenttype,
    a.separator,
    a.def_table,
    a.hideinsearch,
    a.mastertstruct,
    a.masterfield,
    a.dsf,
    a.def_sequence,
        CASE
            WHEN a.pwdalphachar::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS password_alphanumeric,
    a.pwdlength AS password_minlength,
    a.pwdexpiry AS password_expirydays,
    NULL::text AS execapiurl,
    NULL::text AS execapiparameterstring,
    NULL::text AS execapiheaderstring,
    NULL::text AS execapirequeststring,
    NULL::text AS apiresponsetype,
    NULL::text AS apiresponseformat,
    NULL::text AS apifieldname,
    NULL::text AS execapidefname,
    a.runtimecriteria
   FROM coretstructhdr a,
    tstruct_mst_details m
  WHERE a.coretstructhdrid = m.sourceid AND lower(a.modeofentry::text) = 'select from sql'::text
UNION
 SELECT 6 AS sno,
    a.stransid AS transid,
    a.dcname,
    a.name,
    a.caption,
    a.datatype,
    a.customdatatype,
    a.datawidth,
    a.fdecimal,
    a.modeofentry,
    a.sql_editor_detail AS detail,
        CASE
            WHEN a.hidden::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS hidden,
        CASE
            WHEN a.allowempty::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowempty,
        CASE
            WHEN a.readonly::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS readonly,
        CASE
            WHEN a.setcarry::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS setcarry,
        CASE
            WHEN a.savevale::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS savevalue,
    a.exp_editor_expression AS expression,
    a.exp_editor_validateexpression AS validateexpression,
        CASE
            WHEN a.allowduplicate::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowduplicate,
        CASE
            WHEN a.onlypositive::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS onlypositive,
    NULL::text AS sourcekey,
    NULL::text AS carryfield,
    NULL::text AS displaytotal,
    NULL::text AS windowwidth,
    NULL::text AS windowheight,
    NULL::text AS sql,
    'FALSE'::text AS autoselect,
    'FALSE'::text AS refresh,
    NULL::text AS listvalues,
    NULL::text AS prefix,
    NULL::text AS prefix_fields,
    NULL::text AS description,
    NULL::text AS start_no,
    'FALSE'::text AS sactive,
    NULL::text AS no_of_digits,
    'FALSE'::text AS savenormalized,
        CASE
            WHEN a.suggestive_fill::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS suggestive,
    NULL::text AS sourcefield,
    NULL::text AS source_table,
    NULL::text AS datasource,
    NULL::text AS sequence,
    NULL::text AS tname,
    NULL::text AS fromtransid,
    NULL::text AS selectfield,
    NULL::text AS parent,
    NULL::text AS gui,
        CASE
            WHEN a.applycomma::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS applycomma,
    a.mask,
    a.pattern,
    a.pwdchar AS password_character,
    a.hint,
        CASE
            WHEN a.clienvalidation::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS clientvalidation,
    a.searchsql AS search_sql,
    a.displaydetails AS displaydetail,
        CASE
            WHEN a.tabstop::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS tabstop,
    m.sleveno,
    m.sordno,
    a.source,
    a.purpose,
    NULL::text AS cwidth,
    NULL::text AS list,
    NULL::text AS selectform,
    a.fldordno,
    m.trackchanges,
    m.trackchangesmadeby,
    m.selectedusers,
    m.selectedfields,
    a.master,
    'FALSE'::text AS combobox,
    a.componenttype,
    a.separator,
    a.def_table,
    a.hideinsearch,
    a.mastertstruct,
    a.masterfield,
    a.dsf,
    a.def_sequence,
        CASE
            WHEN a.pwdalphachar::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS password_alphanumeric,
    a.pwdlength AS password_minlength,
    a.pwdexpiry AS password_expirydays,
    NULL::text AS execapiurl,
    NULL::text AS execapiparameterstring,
    NULL::text AS execapiheaderstring,
    NULL::text AS execapirequeststring,
    NULL::text AS apiresponsetype,
    NULL::text AS apiresponseformat,
    NULL::text AS apifieldname,
    NULL::text AS execapidefname,
    a.runtimecriteria
   FROM coretstructhdr a,
    tstruct_mst_details m
  WHERE a.coretstructhdrid = m.sourceid AND lower(a.modeofentry::text) = 'fill'::text
UNION
 SELECT DISTINCT 5 AS sno,
    a.stransid AS transid,
    a.dcname,
    a.name,
    a.caption,
    a.datatype,
    a.customdatatype,
    a.datawidth,
    a.fdecimal,
    a.modeofentry,
    a.sql_editor_detail AS detail,
        CASE
            WHEN a.hidden::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS hidden,
        CASE
            WHEN a.allowempty::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowempty,
        CASE
            WHEN a.readonly::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS readonly,
        CASE
            WHEN a.setcarry::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS setcarry,
        CASE
            WHEN a.savevale::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS savevalue,
    a.exp_editor_expression AS expression,
    a.exp_editor_validateexpression AS validateexpression,
        CASE
            WHEN a.allowduplicate::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS allowduplicate,
        CASE
            WHEN a.onlypositive::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS onlypositive,
        CASE
            WHEN a.savenormalized::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS sourcekey,
    NULL::text AS carryfield,
    NULL::text AS displaytotal,
    a.windowwidth::character(1) AS windowwidth,
    a.windowheight::character(1) AS windowheight,
    a.sql_editor_test AS sql,
        CASE
            WHEN a.autoselect_sql::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS autoselect,
        CASE
            WHEN a.refreshonsav::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS refresh,
    NULL::text AS listvalues,
    NULL::text AS prefix,
    NULL::text AS prefix_fields,
    NULL::text AS description,
    NULL::text AS start_no,
    'FALSE'::text AS sactive,
    NULL::text AS no_of_digits,
        CASE
            WHEN a.savenormalized::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS savenormalized,
    'FALSE'::text AS suggestive,
    a.sourcefield,
    a.sourcetable AS source_table,
    a.datasource,
    NULL::text AS sequence,
    NULL::text AS tname,
    NULL::text AS fromtransid,
    NULL::text AS selectfield,
    NULL::text AS parent,
    NULL::text AS gui,
        CASE
            WHEN a.applycomma::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS applycomma,
    a.mask,
    a.pattern,
    a.pwdchar AS password_character,
    a.hint,
        CASE
            WHEN a.clienvalidation::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS clientvalidation,
    a.searchsql AS search_sql,
    a.displaydetails AS displaydetail,
        CASE
            WHEN a.tabstop::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS tabstop,
    m.sleveno,
    m.sordno,
    NULL::text AS source,
    a.purpose,
    NULL::text AS cwidth,
    NULL::text AS list,
    a.selectform_ AS selectform,
    a.fldordno,
    m.trackchanges,
    m.trackchangesmadeby,
    m.selectedusers,
    m.selectedfields,
    NULL::text AS master,
        CASE
            WHEN a.combobox_sql::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS combobox,
    a.componenttype,
    a.separator,
    a.def_table,
    a.hideinsearch,
    a.mastertstruct,
    a.masterfield,
    a.dsf,
    a.def_sequence,
        CASE
            WHEN a.pwdalphachar::text = 'T'::text THEN 'TRUE'::text
            ELSE 'FALSE'::text
        END AS password_alphanumeric,
    a.pwdlength AS password_minlength,
    a.pwdexpiry AS password_expirydays,
    s.execapiurl,
    s.execapiparameterstring,
    s.execapiheaderstring,
    s.execapirequeststring,
    s.apiresponsetype,
    s.apiresponseformat,
    a.apifieldname,
    s.execapidefname,
    a.runtimecriteria
   FROM coretstructhdr a,
    tstruct_mst_details m,
    executeapidef s
  WHERE a.coretstructhdrid = m.sourceid AND a.apidefname = s.executeapidefid AND lower(a.modeofentry::text) = 'select from api'::text;



INSERT INTO customtypes (customtypesid, cancel, sourceid, mapname, username, modifiedon, createdby, createdon, wkid, app_level, app_desc, app_slevel, cancelremarks, wfroles, typename, "datatype", width, deci, namecheck, replacechar, fcharcheck, validchk, modeofentry, cvalues, defaultvalue, sql_editor_details, exp_editor_expression, exp_editor_validateexpression, readonly, chide, cpattern, cmask, cregularexpress) VALUES(1058990000006, 'F', 0, NULL, 'admin', '2022-07-04 12:59:55.000', 'admin', '2022-07-04 12:59:55.000', NULL, 1, 1, NULL, NULL, NULL, 'Address', 'Character', 1000, 0.000, 'ADD', 'Address', 'T', 'T', 'Accept', NULL, NULL, NULL, NULL, NULL, 'F', 'F', NULL, NULL, NULL);
INSERT INTO customtypes (customtypesid, cancel, sourceid, mapname, username, modifiedon, createdby, createdon, wkid, app_level, app_desc, app_slevel, cancelremarks, wfroles, typename, "datatype", width, deci, namecheck, replacechar, fcharcheck, validchk, modeofentry, cvalues, defaultvalue, sql_editor_details, exp_editor_expression, exp_editor_validateexpression, readonly, chide, cpattern, cmask, cregularexpress) VALUES(1058990000005, 'F', 0, NULL, 'admin', '2022-07-04 12:59:38.000', 'admin', '2022-07-04 12:59:38.000', NULL, 1, 1, NULL, NULL, NULL, 'Boolean', 'Character', 10, 0.000, 'ADD', 'Boolean', 'T', 'T', 'Accept', NULL, NULL, NULL, NULL, NULL, 'F', 'F', NULL, NULL, NULL);
INSERT INTO customtypes (customtypesid, cancel, sourceid, mapname, username, modifiedon, createdby, createdon, wkid, app_level, app_desc, app_slevel, cancelremarks, wfroles, typename, "datatype", width, deci, namecheck, replacechar, fcharcheck, validchk, modeofentry, cvalues, defaultvalue, sql_editor_details, exp_editor_expression, exp_editor_validateexpression, readonly, chide, cpattern, cmask, cregularexpress) VALUES(1058990000004, 'F', 0, NULL, 'admin', '2022-07-04 12:59:13.000', 'admin', '2022-07-04 12:59:13.000', NULL, 1, 1, NULL, NULL, NULL, 'Date Range', 'Character', 500, 0.000, 'ADD', 'Date Range', 'T', 'T', 'Accept', NULL, NULL, NULL, NULL, NULL, 'F', 'F', NULL, NULL, NULL);
INSERT INTO customtypes (customtypesid, cancel, sourceid, mapname, username, modifiedon, createdby, createdon, wkid, app_level, app_desc, app_slevel, cancelremarks, wfroles, typename, "datatype", width, deci, namecheck, replacechar, fcharcheck, validchk, modeofentry, cvalues, defaultvalue, sql_editor_details, exp_editor_expression, exp_editor_validateexpression, readonly, chide, cpattern, cmask, cregularexpress) VALUES(1058990000003, 'F', 0, NULL, 'admin', '2022-07-04 12:59:03.000', 'admin', '2022-07-04 12:59:03.000', NULL, 1, 1, NULL, NULL, NULL, 'File upload field', 'Character', 250, 0.000, 'ADD', 'File upload field', 'T', 'T', 'Accept', NULL, NULL, NULL, NULL, NULL, 'F', 'F', NULL, NULL, NULL);
INSERT INTO customtypes (customtypesid, cancel, sourceid, mapname, username, modifiedon, createdby, createdon, wkid, app_level, app_desc, app_slevel, cancelremarks, wfroles, typename, "datatype", width, deci, namecheck, replacechar, fcharcheck, validchk, modeofentry, cvalues, defaultvalue, sql_editor_details, exp_editor_expression, exp_editor_validateexpression, readonly, chide, cpattern, cmask, cregularexpress) VALUES(1058990000002, 'F', 0, NULL, 'admin', '2022-07-04 12:58:51.000', 'admin', '2022-07-04 12:58:51.000', NULL, 1, 1, NULL, NULL, NULL, 'Number range', 'Character', 500, 0.000, 'ADD', 'Number range', 'T', 'T', 'Accept', NULL, NULL, NULL, NULL, NULL, 'F', 'F', NULL, NULL, NULL);
INSERT INTO customtypes (customtypesid, cancel, sourceid, mapname, username, modifiedon, createdby, createdon, wkid, app_level, app_desc, app_slevel, cancelremarks, wfroles, typename, "datatype", width, deci, namecheck, replacechar, fcharcheck, validchk, modeofentry, cvalues, defaultvalue, sql_editor_details, exp_editor_expression, exp_editor_validateexpression, readonly, chide, cpattern, cmask, cregularexpress) VALUES(1058990000001, 'F', 0, NULL, 'admin', '2022-07-04 12:58:39.000', 'admin', '2022-07-04 12:58:39.000', NULL, 1, 1, NULL, NULL, NULL, 'Time Range', 'Character', 500, 0.000, 'ADD', 'Time Range', 'T', 'T', 'Accept', NULL, NULL, NULL, NULL, NULL, 'F', 'F', NULL, NULL, NULL);
INSERT INTO customtypes (customtypesid, cancel, sourceid, mapname, username, modifiedon, createdby, createdon, wkid, app_level, app_desc, app_slevel, cancelremarks, wfroles, typename, "datatype", width, deci, namecheck, replacechar, fcharcheck, validchk, modeofentry, cvalues, defaultvalue, sql_editor_details, exp_editor_expression, exp_editor_validateexpression, readonly, chide, cpattern, cmask, cregularexpress) VALUES(1058990000000, 'F', 0, NULL, 'admin', '2022-07-04 12:58:25.000', 'admin', '2022-07-04 12:58:25.000', NULL, 1, 1, NULL, NULL, NULL, 'Website', 'Character', 250, 0.000, 'ADD', 'Website', 'T', 'T', 'Accept', NULL, NULL, NULL, NULL, NULL, 'F', 'F', NULL, NULL, NULL);